package com.china08.yxyapi.repository.db.lesson;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;

import com.china08.yxyapi.entity.db.lessons.cloud.YxyLessonsCloudCatalog;

public interface YxyLessonsCloudCatalogRepository extends JpaRepository<YxyLessonsCloudCatalog, String> {

    List<YxyLessonsCloudCatalog> findBySchoolId(String schoolId);

    List<YxyLessonsCloudCatalog> findBySchoolIdOrderByOrderNumAsc(String schoolId);

    List<YxyLessonsCloudCatalog> findBySchoolIdNotOrderByOrderNumAsc(String schoolId);

    List<YxyLessonsCloudCatalog> findBySchoolIdNotOrderByOrderNumAscCreatedDateAsc(String schoolId);

    List<YxyLessonsCloudCatalog> findBySchoolIdAndPid(String schoolId, String pid);

    List<YxyLessonsCloudCatalog> findByPid(String pid);

    List<YxyLessonsCloudCatalog> findBySchoolIdAndPidOrderByOrderNumAsc(String schoolId, String pid);

    List<YxyLessonsCloudCatalog> findByPidOrderByOrderNumAsc(String pid);

    Integer countBySchoolIdAndLevelAndPid(String schoolId, Integer level, String pid);

    YxyLessonsCloudCatalog findById(String id);

    List<YxyLessonsCloudCatalog> findByLevel(int i);

    List<YxyLessonsCloudCatalog> findByPidOrderByOrderNumAscCreatedDateAsc(String string);

}
